Log Database
FastBCP supports logging to a Microsoft SQL Server or PostgreSQL database.
To enable database logging, configure the log database connection string in a settings file:
- The default settings file is
FastBCP_settings.json - You can specify a custom settings file using the
--settingsfileparameter
Log table is created automatically if not exists but it is not indexed. Up to you to choose you indexed column(s) you prefer to index. We Advice you to index event_timestamp column and run_id
No internal purge of the log table, it is up to you to decide when and how filter the log table
Complete configuration examples for both MSSQL and PostgreSQL are available in the Configuration Examples page.
In case the database is not reachable, FastBCP will fail and will refuse to continue. If you want to continue without logging in the database, you can rename the FastBCP_settings.json file to something else (like FastBCP_settings.json.save) and FastBCP will use the console log only.